***********************************
** The Effects of House Prices and Home Equity Extraction on Career Outcomes
** by Jacelly Cespedes, Zack Liu, and Carlos Parra
***********************************

// Directories
global data C:\Users\Dropbox\Data
global output C:\Users\Dropbox\Data\Results


***********************************
** tables
***********************************

cd "$data"
use "data_for_reg_v3", clear


*** Table 1: Summary statistics
cd "$output"
tabstat age_2007 female movie_0306 num_awards_pre total_hp_movie_pre total_movie_bq4_pre total_movie_sq1_pre properties HP_2007 refinance_ex_ante credit_line_ex_ante , stat(n mean sd) col(stat) // ex-ante covariates
tabstat  occ1 occ2 occ3 , stat(n mean sd) col(stat)  // occuppation
tabstat HP_change total_movie  total_movie_bq4 total_movie_sq1 hp_movie_dum total_hp_movie  movie_rating won_nom_award leading_role_mean jud_liens tax_liens non_tax_liens, stat(n mean sd) col(stat)



*** Table 2: Housing price shocks and film choices 
reghdfe hp_movie_dum HP_change female age_2007 num_awards_pre movie_0306 total_hp_movie_pre     if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2) vce(cluster zip) 
outreg2 using "$output\T2_hp_Shocks",  bdec(3) sdec(3) drop (cons) addtext(Occupation FE, Yes, County FE, Yes)   nocons replace

reghdfe total_hp_movie HP_change female age_2007 num_awards_pre movie_0306 total_hp_movie_pre   if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T2_hp_Shocks",  bdec(3) sdec(3) drop (cons) addtext(Occupation FE, Yes, County FE, Yes)   nocons

reghdfe total_movie HP_change female age_2007 num_awards_pre movie_0306 total_hp_movie_pre       if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T2_hp_Shocks",  bdec(3) sdec(3) drop (cons) addtext(Occupation FE, Yes, County FE, Yes)   nocons

reghdfe total_movie_bq4 HP_change female age_2007 num_awards_pre movie_0306  total_movie_bq4_pre     if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T2_hp_Shocks",  bdec(3) sdec(3) drop (cons) addtext(Occupation FE, Yes, County FE, Yes)   nocons

reghdfe total_movie_sq1 HP_change female age_2007 num_awards_pre movie_0306  total_movie_sq1_pre    if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T2_hp_Shocks",  bdec(3) sdec(3) drop (cons) addtext(Occupation FE, Yes, County FE, Yes)   nocon  see tex



*** Table 3: Other film quality and career choice measures
reghdfe won_nom_award HP_change female age_2007 num_awards_pre movie_0306 total_hp_movie_pre  if movie_0306 > 0 & renter == 0  , absorb(fipscounty occ1 occ2 ) vce(cluster zip)
outreg2 using "$output\T3_other_Quality",  bdec(3) sdec(3) drop (cons) addtext(Occupation FE, Yes, County FE, Yes) nocon replace

reghdfe movie_rating HP_change female age_2007 num_awards_pre movie_0306 total_hp_movie_pre movie_rating_pre   if movie_0306 > 0 & renter == 0  , absorb(fipscounty occ1 occ2 ) vce(cluster zip)
outreg2 using "$output\T3_other_Quality",  bdec(3) sdec(3) drop (cons) addtext(Occupation FE, Yes, County FE, Yes) nocon

reghdfe leading_role_mean HP_change female age_2007 num_awards_pre movie_0306 total_hp_movie_pre leading_role_mean_pre  if movie_0306 > 0 & renter == 0  & occupation=="actors" , absorb(fipscounty occ1 occ2) vce(cluster zip)
outreg2 using "$output\T3_other_Quality",  bdec(3) sdec(3) drop (cons) addtext(Occupation FE, Yes, County FE, Yes) nocon  tex 



** Table 4: Housing price shocks and film choices: Homeowners versus renters
gen homeowner=(1-renter)
gen hp_home=homeowner*HP_change

reghdfe hp_movie_dum  HP_change hp_home homeowner female age_2007 num_awards_pre movie_0306 total_hp_movie_pre   if movie_0306 > 0  , absorb(fipscounty occ1 occ2 )  vce(cluster zip)
outreg2 using "$output\T4_homeowners_Renters",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocons replace

reghdfe total_hp_movie HP_change hp_home homeowner female age_2007 num_awards_pre movie_0306 total_hp_movie_pre    if movie_0306 > 0  , absorb(fipscounty occ1 occ2 )  vce(cluster zip)
outreg2 using "$output\T4_homeowners_Renters",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocons

reghdfe total_movie HP_change hp_home homeowner female age_2007 num_awards_pre movie_0306 total_hp_movie_pre      if movie_0306 > 0 , absorb(fipscounty occ1 occ2 )  vce(cluster zip)
outreg2 using "$output\T4_homeowners_Renters",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocons

reghdfe total_movie_bq4 HP_change hp_home homeowner female age_2007 num_awards_pre movie_0306  total_movie_bq4_pre    if movie_0306 > 0 , absorb(fipscounty occ1 occ2 )  vce(cluster zip)
outreg2 using "$output\T4_homeowners_Renters",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_movie_bq4_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocons

reghdfe total_movie_sq1 HP_change hp_home homeowner female age_2007 num_awards_pre movie_0306  total_movie_sq1_pre   if movie_0306 > 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T4_homeowners_Renters",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_movie_sq1_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocon  see tex



*** Table 5: Housing price shocks and home equity extraction
gen HP_change_refi = refinance_ex_ante*HP_change
gen HP_change_line = credit_line_ex_ante*HP_change


// Panel A: refinance ex-ante
reghdfe hp_movie_dum HP_change HP_change_refi refinance_ex_ante female age_2007 num_awards_pre movie_0306 total_hp_movie_pre  if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T5_home_Equity_A",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocons replace

reghdfe total_hp_movie HP_change HP_change_refi refinance_ex_ante female age_2007 num_awards_pre movie_0306 total_hp_movie_pre    if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T5_home_Equity_A",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocons 

reghdfe total_movie HP_change HP_change_refi refinance_ex_ante female age_2007 num_awards_pre movie_0306 total_hp_movie_pre      if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T5_home_Equity_A",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocon 

reghdfe total_movie_bq4 HP_change HP_change_refi refinance_ex_ante  female age_2007 num_awards_pre movie_0306  total_movie_bq4_pre    if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T5_home_Equity_A",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_movie_bq4_pre cons)  addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocon 

reghdfe total_movie_sq1 HP_change HP_change_refi refinance_ex_ante  female age_2007 num_awards_pre movie_0306  total_movie_sq1_pre   if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T5_home_Equity_A",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_movie_sq1_pre cons)  addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocon  tex 

// Panel B: heloc ex-ante
reghdfe hp_movie_dum HP_change HP_change_line credit_line_ex_ante female age_2007 num_awards_pre movie_0306 total_hp_movie_pre    if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T5_home_Equity_B",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocons replace

reghdfe total_hp_movie HP_change HP_change_line credit_line_ex_ante female age_2007 num_awards_pre movie_0306 total_hp_movie_pre    if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T5_home_Equity_B",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocons 

reghdfe total_movie HP_change HP_change_line credit_line_ex_ante female age_2007 num_awards_pre movie_0306 total_hp_movie_pre       if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T5_home_Equity_B",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocon 

reghdfe total_movie_bq4 HP_change HP_change_line credit_line_ex_ante  female age_2007 num_awards_pre movie_0306  total_movie_bq4_pre     if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T5_home_Equity_B",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_movie_bq4_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocon 

reghdfe total_movie_sq1 HP_change HP_change_line credit_line_ex_ante  female age_2007 num_awards_pre movie_0306  total_movie_sq1_pre    if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T5_home_Equity_B",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_movie_sq1_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocon  tex 



*** Table 6: Heterogeneity of housing price shocks and film choices
// Panel A: pretreatment credits in the top quartile
xtile num_mov_q=movie_0306, nq(4)
gen num_mov_q4=(num_mov_q==4)
gen HP_change_numq4=HP_change*num_mov_q4

reghdfe hp_movie_dum HP_change HP_change_numq4 num_mov_q4 female age_2007 num_awards_pre  total_hp_movie_pre    if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T6_heterogeneity_Active_A",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre  total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocons replace

reghdfe total_hp_movie HP_change HP_change_numq4 num_mov_q4 female age_2007 num_awards_pre  total_hp_movie_pre    if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T6_heterogeneity_Active_A",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre  total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocons 

reghdfe total_movie HP_change HP_change_numq4 num_mov_q4 female age_2007 num_awards_pre  total_hp_movie_pre       if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T6_heterogeneity_Active_A",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre  total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocon 

reghdfe total_movie_bq4 HP_change HP_change_numq4 num_mov_q4  female age_2007 num_awards_pre   total_movie_bq4_pre     if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T6_heterogeneity_Active_A",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre  total_movie_bq4_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocon 

reghdfe total_movie_sq1 HP_change HP_change_numq4 num_mov_q4  female age_2007 num_awards_pre movie_0306  total_movie_sq1_pre    if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T6_heterogeneity_Active_A",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre  total_movie_sq1_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocon  tex 

// Panel B: pretreatment high-profile credits in the top quartile
xtile total_hp_movie_pre_q=total_hp_movie_pre , nq(4)
gen total_hp_movie_pre_q4=(total_hp_movie_pre_q==4)
gen HP_change_hp_pre_q4=HP_change*total_hp_movie_pre_q4

reghdfe hp_movie_dum HP_change HP_change_hp_pre_q4 total_hp_movie_pre_q4 female age_2007 num_awards_pre  total_hp_movie_pre    if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T6_heterogeneity_HPmovies_B",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre  total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocons replace

reghdfe total_hp_movie HP_change HP_change_hp_pre_q4 total_hp_movie_pre_q4 female age_2007 num_awards_pre  total_hp_movie_pre    if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T6_heterogeneity_HPmovies_B",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre  total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocons 

reghdfe total_movie HP_change HP_change_hp_pre_q4 total_hp_movie_pre_q4 female age_2007 num_awards_pre  total_hp_movie_pre       if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T6_heterogeneity_HPmovies_B",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre  total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocon 

reghdfe total_movie_bq4 HP_change HP_change_hp_pre_q4 total_hp_movie_pre_q4  female age_2007 num_awards_pre   total_movie_bq4_pre     if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T6_heterogeneity_HPmovies_B",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre  total_movie_bq4_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocon 

reghdfe total_movie_sq1 HP_change HP_change_hp_pre_q4 total_hp_movie_pre_q4  female age_2007 num_awards_pre movie_0306  total_movie_sq1_pre    if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T6_heterogeneity_HPmovies_B",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre  total_movie_sq1_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocon  tex 

// Panel C: pretreatment popularity in the top quartile (i.e., the lower the Starmeter, the more popular the individual)
xtile star_pre_q = star_pre, nq(4)
gen star_meter_pre_q1 = (star_pre_q==1) if star_pre_q!=. 
gen HP_change_star_pre_q1=HP_change*star_meter_pre_q1

reghdfe hp_movie_dum HP_change HP_change_star_pre_q1 star_meter_pre_q1 female age_2007 num_awards_pre movie_0306 total_hp_movie_pre    if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T6_heterogeneity_Popularity_C",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocons replace

reghdfe total_hp_movie HP_change HP_change_star_pre_q1 star_meter_pre_q1 female age_2007 num_awards_pre movie_0306 total_hp_movie_pre    if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T6_heterogeneity_Popularity_C",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocons 

reghdfe total_movie HP_change HP_change_star_pre_q1 star_meter_pre_q1 female age_2007 num_awards_pre movie_0306 total_hp_movie_pre       if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T6_heterogeneity_Popularity_C",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocon 

reghdfe total_movie_bq4 HP_change HP_change_star_pre_q1 star_meter_pre_q1  female age_2007 num_awards_pre movie_0306  total_movie_bq4_pre     if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T6_heterogeneity_Popularity_C",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_movie_bq4_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocon 

reghdfe total_movie_sq1 HP_change HP_change_star_pre_q1 star_meter_pre_q1  female age_2007 num_awards_pre movie_0306  total_movie_sq1_pre    if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T6_heterogeneity_Popularity_C",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_movie_sq1_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocon  tex 



*** Table 7: Long-term effects of housing price shocks on an individual’s career path
cd "$data"
use "data_for_long_term_2018", clear

// Panel A: main outcomes
reghdfe hp_movie_dum HP_change female age_2007 num_awards_pre movie_0306 total_hp_movie_pre     if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2) vce(cluster zip) 
outreg2 using "$output\T7_long_Term_A", bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes) nocon replace

reghdfe total_hp_movie HP_change female age_2007 num_awards_pre movie_0306 total_hp_movie_pre   if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2) vce(cluster zip)
outreg2 using "$output\T7_long_Term_A", bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes) nocon 

reghdfe total_movie HP_change female age_2007 num_awards movie_0306 total_hp_movie_pre     if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2) vce(cluster zip)
outreg2 using "$output\T7_long_Term_A", bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes) nocon

reghdfe total_movie_bq4 HP_change female age_2007 num_awards_pre movie_0306 total_movie_bq4_pre    if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2) vce(cluster zip)
outreg2 using "$output\T7_long_Term_A", bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306  total_movie_bq4_pre  cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes) nocon

reghdfe total_movie_sq1 HP_change female age_2007 num_awards_pre movie_0306 total_movie_sq1_pre   if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2) vce(cluster zip)
outreg2 using "$output\T7_long_Term_A", bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_movie_sq1_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes) nocon tex

// Panel B: other outcomes
reghdfe won_nom_award HP_change female age_2007 num_awards_pre movie_0306 total_hp_movie_pre won_nom_award_pre  if movie_0306 > 0 & renter == 0  , absorb(fipscounty occ1 occ2) vce(cluster zip)
outreg2 using "$output\T7_long_Term_B", bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre won_nom_award_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes) nocon  replace

reghdfe movie_rating HP_change female age_2007 num_awards_pre movie_0306 total_hp_movie_pre movie_rating_pre  if movie_0306 > 0 & renter == 0  , absorb(fipscounty occ1 occ2) vce(cluster zip)
outreg2 using "$output\T7_long_Term_B", bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre movie_rating_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes) nocon  

reghdfe leading_role_mean HP_change female age_2007 num_awards_pre movie_0306 total_hp_movie_pre leading_role_mean_pre   if movie_0306 > 0 & renter == 0  & occupation=="actors" , absorb(fipscounty occ1 occ2) vce(cluster zip)
outreg2 using "$output\T7_long_Term_B", bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre leading_role_mean_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes) nocon 

reghdfe popularity HP_change female age_2007 num_awards_pre movie_0306 total_hp_movie_pre popularity_pre  if movie_0306 > 0 & renter == 0  , absorb(fipscounty occ1 occ2) vce(cluster zip)
outreg2 using "$output\T7_long_Term_B", bdec(3) sdec(3) drop ( female age_2007 num_awards_pre movie_0306 total_hp_movie_pre popularity_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes) nocon  tex




** Table 8: Housing price shocks and delinquency
cd "$data"
use "data_for_reg_v3", clear

reghdfe tax_liens HP_change   female age_2007 num_awards_pre movie_0306 total_hp_movie_pre    if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T8_delinquency",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocons replace

reghdfe non_tax_liens HP_change    female age_2007 num_awards_pre movie_0306 total_hp_movie_pre     if movie_0306 > 0 & renter == 0 , absorb(fipscounty occ1 occ2)  vce(cluster zip)
outreg2 using "$output\T8_delinquency",  bdec(3) sdec(3) drop (female age_2007 num_awards_pre movie_0306 total_hp_movie_pre cons) addtext(Controls, Yes, Occupation FE, Yes, County FE, Yes)   nocon tex




